Search for: All records

Existing deep-learning approaches to semantic column type annotation (CTA) have important shortcomings: they rely on semantic types which are fixed at training time; require a large number of training samples per type; incur high run-time inference costs; and their performance can degrade when evaluated on novel datasets, even when types remain constant. Large language models have exhibited strong zero-shot classification performance on a wide range of tasks and in this paper we explore their use for CTA. We introduce ArcheType, a simple, practical method for context sampling, prompt serialization, model querying, and label remapping, which enables large language models to solve CTA problems in a fully zero-shot manner. We ablate each component of our method separately, and establish that improvements to context sampling and label remapping provide the most consistent gains. ArcheType establishes a new state-of-the-art performance on zero-shot CTA benchmarks (including three new domain-specific benchmarks which we release along with this paper), and when used in conjunction with classical CTA techniques, it outperforms a SOTA DoDuo model on the fine-tuned SOTAB benchmark. 

Deforestation poses a global threat to biodiversity and its capacity to deliver ecosystem services. Yet, the impacts of deforestation on soil biodiversity and its associated ecosystem services remain virtually unknown. We generated a global dataset including 696 paired-site observations to investigate how native forest conversion to other land uses affects soil properties, biodiversity, and functions associated with the delivery of multiple ecosystem services. The conversion of native forests to plantations, grasslands, and croplands resulted in higher bacterial diversity and more homogeneous fungal communities dominated by pathogens and with a lower abundance of symbionts. Such conversions also resulted in significant reductions in carbon storage, nutrient cycling, and soil functional rates related to organic matter decomposition. Responses of the microbial community to deforestation, including bacterial and fungal diversity and fungal guilds, were predominantly regulated by changes in soil pH and total phosphorus. Moreover, we found that soil fungal diversity and functioning in warmer and wetter native forests is especially vulnerable to deforestation. Our work highlights that the loss of native forests to managed ecosystems poses a major global threat to the biodiversity and functioning of soils and their capacity to deliver ecosystem services.